﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace KJSyncXP.Oracle.Model {

	[JsonObject(MemberSerialization.OptIn), Table(DisableSyncStructure = true)]
	public partial class KJ_TEST_STANDARD {

		[JsonProperty, Column(DbType = "DATE(7)", InsertValueSql = "SYSDATE")]
		public DateTime? CREATION_DATE { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? END_DATE { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string EQP { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(32 BYTE)", IsNullable = false)]
		public string GUID { get; set; } = "RAWTOHEX(SYS_GUID())";

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? KJ_ID { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? MAX_DATA { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? MIN_DATA { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string PART_NUMBER { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? RECEIVE_DATE { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string RECEIVE_FLAG { get; set; }

		[JsonProperty, Column(DbType = "DATE(7)")]
		public DateTime? START_DATE { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string TEST_PROJECT { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(20 BYTE)")]
		public string TEST_TYPE { get; set; }

    }

}
